Large Data Pivot Grid Overview

The Large Data Pivot Grid is a new Dashboard Component which supports connecting to external tables or large database tables for “pivot” style analytic reporting. The Large Data Pivot Grid allows the designer to integrate data, found in external tables, seamlessly into the OneStream environment through a Dashboard for analytic reporting. The Large Data Pivot Grid’s Paging feature and Server Based Processing enables the component to manage very large data sets/tables. 

The Large Data Pivot Grid processes each request for data as a process on the application server.  User pivots and filter settings are processed on the application server, returning only a “slice” of data to the client machine.  The entire table contents is not returned to the client machine, accounting for the primary difference between the Large Data Pivot Grid and Standard Pivot Grid Components.  This feature to manage the Pivot requests on the server, returning the slices by page is what allows the Large Data Pivot Grid to manage very large datasets. 

Because processing is performed on the application server, and the “slices” are returned to the client for display, performance can vary by user’s proximity to the application or the size of the dataset being returned.

The Large Data Pivot Grid can handle much larger data sets compared to Adapter based “standard” Pivot Grid.  The Paging controls allow the pivoting to be efficiently managed for the client.

Database Locations

There are three database locations the can be used to supply the data set for the adapter.

External

The External database location can be any external database table accessible to the Component.  Such an example is the BI Blend external database tables.

• External Table which can contain millions of records.

  Any External database table must be added to the OneStream Server Configuration Utility as a Database Server Connection and designated Is External Database.

  

Framework

The Framework Database referenced in the OneStream Server Configuration Utility Database Type as Framework.

Application

The Application Database under which the product is currently running.